FaNSLDSWork12

EntityType | Independent
Logical Entity Name | FaNSLDSWork12
Default Table Name | FaNSLDSWork12
Logical Only | NO
Owner | dbo
Definition |
Note |

FaNSLDSWork12 Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaNSLDSWork12ID |  | INTEGER | NO |
FaISIR12ID |  | INTEGER | YES |
Name |  | CHAR(60) | YES |
SSN |  | CHAR(17) | YES |
TransactionProcessed |  | DATETIME | YES |
OverPaymentChangeFlag |  | CHAR(1) | YES |
DefaultChangeFlag |  | CHAR(1) | YES |
DefaultedLoanFlag |  | CHAR(1) | YES |
DischargedChangeFlag |  | CHAR(1) | YES |
DischargedLoanFlag |  | CHAR(1) | YES |
SatRepayChangeFlag |  | CHAR(1) | YES |
LoanSatRepayFlag |  | CHAR(1) | YES |
ActiveBankruptChangeFlag |  | CHAR(1) | YES |
ActiveBankruptcyFlag |  | CHAR(1) | YES |
PellOverPayFlag |  | CHAR(1) | YES |
PellOverPayContact |  | CHAR(12) | YES |
SEOGOverpayFlag |  | CHAR(1) | YES |
SEOGOverpayContact |  | CHAR(12) | YES |
PerkinsOverpayFlag |  | CHAR(1) | YES |
PerkinsOverpayContact |  | CHAR(12) | YES |
ACGOverPayFlag |  | CHAR(1) | YES |
ACGOverPayContact |  | CHAR(12) | YES |
SMARTOverPayFlag |  | CHAR(1) | YES |
SMARTOverPayContact |  | CHAR(12) | YES |
TEACHOverPayFlag |  | CHAR(1) | YES |
TEACHLoanConversionFlag |  | CHAR(1) | YES |
TEACHOverPayContact |  | CHAR(12) | YES |
IRQAFGSerGrantOverpayFlag |  | CHAR(1) | YES |
IRQAFGSerGrantOverpayContact |  | CHAR(12) | YES |
AggrTEACHBal |  | CHAR(8) | YES |
AggrTEACHTotal |  | CHAR(8) | YES |
AggrTEACHUnderGradDisbAmount |  | CHAR(8) | YES |
AggrTEACHGradDisbAmount |  | CHAR(8) | YES |
AggrSubsidizedBal |  | CHAR(8) | YES |
AggrSubsidizedDisbPending |  | CHAR(8) | YES |
AggrSubsidizedTotal |  | CHAR(8) | YES |
AggrCombinedBal |  | CHAR(8) | YES |
AggrCombinedDisbPending |  | CHAR(8) | YES |
AggrCombinedTotal |  | CHAR(8) | YES |
AggrConsolidateBal |  | CHAR(8) | YES |
AggrConsolidatedTotal |  | CHAR(8) | YES |
PerkinsLoanChangeFlag |  | CHAR(1) | YES |
PerkinsPrinBalance |  | CHAR(8) | YES |
PerkinsCurrYrLoanAmount |  | CHAR(8) | YES |
PerkinsFirstDisbPrior |  | CHAR(1) | YES |
PellPaymentChangeFlag |  | CHAR(1) | YES |
ACGPaymentChangeFlag |  | CHAR(1) | YES |
SMARTPaymentChangeFlag |  | CHAR(1) | YES |
TEACHLoanChangeFlag |  | CHAR(1) | YES |
TEACHPaymentChangeFlag |  | CHAR(1) | YES |
AdditionalTEACHFlag |  | CHAR(1) | YES |
AdditionalPellFlag |  | CHAR(1) | YES |
AdditionalACGFlag |  | CHAR(1) | YES |
AdditionalSMARTFlag |  | CHAR(1) | YES |
AdditionalLoansFlag |  | CHAR(1) | YES |
AggrLoanChangeFlag |  | CHAR(1) | YES |
DLPromNote |  | CHAR(20) | YES |
DLPlusPromNote |  | CHAR(20) | YES |
DLGradPlusPromNote |  | CHAR(20) | YES |
FFELPromNote |  | CHAR(1) | YES |
FFELLenderCode |  | CHAR(6) | YES |
SubsidizedLoanLimitFlag |  | CHAR(15) | YES |
CombinedLoanLimitFlag |  | CHAR(15) | YES |
NSLDSPostReasonCode |  | CHAR(8) | YES |
AggrUnSubBal |  | CHAR(8) | YES |
AggrUnSubsidizedDisb |  | CHAR(8) | YES |
AggrUnsubTotal |  | CHAR(8) | YES |
GradSubsidizedLoanLimitFlag |  | CHAR(15) | YES |
GradCombinedLoanLimitFlag |  | CHAR(15) | YES |
FraudLoanFlag |  | CHAR(15) | YES |
PellSchoolCode1 |  | CHAR(8) | YES |
PellSchoolCode2 |  | CHAR(8) | YES |
PellSchoolCode3 |  | CHAR(8) | YES |
PellTransactionNumber1 |  | CHAR(2) | YES |
PellTransactionNumber2 |  | CHAR(2) | YES |
PellTransactionNumber3 |  | CHAR(2) | YES |
PellScheduledAmount1 |  | CHAR(7) | YES |
PellScheduledAmount2 |  | CHAR(7) | YES |
PellScheduledAmount3 |  | CHAR(7) | YES |
PellAwardAmt1 |  | CHAR(7) | YES |
PellAwardAmt2 |  | CHAR(7) | YES |
PellAwardAmt3 |  | CHAR(7) | YES |
PellAmountPaidToDate1 |  | CHAR(7) | YES |
PellAmountPaidToDate2 |  | CHAR(7) | YES |
PellAmountPaidToDate3 |  | CHAR(7) | YES |
PellPercentAwardUsed1 |  | CHAR(6) | YES |
PellPercentAwardUsed2 |  | CHAR(6) | YES |
PellPercentAwardUsed3 |  | CHAR(6) | YES |
PellLastUpdateDate1 |  | CHAR(10) | YES |
PellLastUpdateDate2 |  | CHAR(10) | YES |
PellLastUpdateDate3 |  | CHAR(10) | YES |
PellVerificationFlag1 |  | CHAR(3) | YES |
PellVerificationFlag2 |  | CHAR(3) | YES |
PellVerificationFlag3 |  | CHAR(3) | YES |
PellEFC1 |  | CHAR(6) | YES |
PellEFC2 |  | CHAR(6) | YES |
PellEFC3 |  | CHAR(6) | YES |
PellAdditionalEligIndicator1 |  | CHAR(1) | YES |
PellAdditionalEligIndicator2 |  | CHAR(1) | YES |
PellAdditionalEligIndicator3 |  | CHAR(1) | YES |
ACGSchoolCode1 |  | CHAR(8) | YES |
ACGSchoolCode2 |  | CHAR(8) | YES |
ACGSchoolCode3 |  | CHAR(8) | YES |
ACGTransactionNumber1 |  | CHAR(2) | YES |
ACGTransactionNumber2 |  | CHAR(2) | YES |
ACGTransactionNumber3 |  | CHAR(2) | YES |
ACGAwardAmt1 |  | CHAR(7) | YES |
ACGAwardAmt2 |  | CHAR(7) | YES |
ACGAwardAmt3 |  | CHAR(7) | YES |
ACGAmountPaidToDate1 |  | CHAR(7) | YES |
ACGAmountPaidToDate2 |  | CHAR(7) | YES |
ACGAmountPaidToDate3 |  | CHAR(7) | YES |
ACGLastUpdateDate1 |  | CHAR(10) | YES |
ACGLastUpdateDate2 |  | CHAR(10) | YES |
ACGLastUpdateDate3 |  | CHAR(10) | YES |
ACGSchoolYear1 |  | CHAR(1) | YES |
ACGSchoolYear2 |  | CHAR(1) | YES |
ACGSchoolYear3 |  | CHAR(1) | YES |
ACGSequenceCode1 |  | CHAR(3) | YES |
ACGSequenceCode2 |  | CHAR(3) | YES |
ACGSequenceCode3 |  | CHAR(3) | YES |
ACGEligibilityCode1 |  | CHAR(25) | YES |
ACGEligibilityCode2 |  | CHAR(25) | YES |
ACGEligibilityCode3 |  | CHAR(25) | YES |
ACGHighSchoolProgramCode1 |  | CHAR(6) | YES |
ACGHighSchoolProgramCode2 |  | CHAR(6) | YES |
ACGHighSchoolProgramCode3 |  | CHAR(6) | YES |
SMARTSchoolCode1 |  | CHAR(8) | YES |
SMARTSchoolCode2 |  | CHAR(8) | YES |
SMARTSchoolCode3 |  | CHAR(8) | YES |
SMARTTransactionNumber1 |  | CHAR(2) | YES |
SMARTTransactionNumber2 |  | CHAR(2) | YES |
SMARTTransactionNumber3 |  | CHAR(2) | YES |
SMARTAwardAmt1 |  | CHAR(7) | YES |
SMARTAwardAmt2 |  | CHAR(7) | YES |
SMARTAwardAmt3 |  | CHAR(7) | YES |
SMARTAmountPaidToDate1 |  | CHAR(7) | YES |
SMARTAmountPaidToDate2 |  | CHAR(7) | YES |
SMARTAmountPaidToDate3 |  | CHAR(7) | YES |
SMARTLastUpdateDate1 |  | CHAR(10) | YES |
SMARTLastUpdateDate2 |  | CHAR(10) | YES |
SMARTLastUpdateDate3 |  | CHAR(10) | YES |
SMARTSchoolYear1 |  | CHAR(1) | YES |
SMARTSchoolYear2 |  | CHAR(1) | YES |
SMARTSchoolYear3 |  | CHAR(1) | YES |
SMARTSequenceCode1 |  | CHAR(3) | YES |
SMARTSequenceCode2 |  | CHAR(3) | YES |
SMARTSequenceCode3 |  | CHAR(3) | YES |
SMARTCIPCode1 |  | CHAR(7) | YES |
SMARTCIPCode2 |  | CHAR(7) | YES |
SMARTCIPCode3 |  | CHAR(7) | YES |
TEACHSchoolCode1 |  | CHAR(8) | YES |
TEACHSchoolCode2 |  | CHAR(8) | YES |
TEACHSchoolCode3 |  | CHAR(8) | YES |
TEACHTransactionNumber1 |  | CHAR(2) | YES |
TEACHTransactionNumber2 |  | CHAR(2) | YES |
TEACHTransactionNumber3 |  | CHAR(2) | YES |
TEACHAwardAmt1 |  | CHAR(7) | YES |
TEACHAwardAmt2 |  | CHAR(7) | YES |
TEACHAwardAmt3 |  | CHAR(7) | YES |
TEACHAmountPaidToDate1 |  | CHAR(7) | YES |
TEACHAmountPaidToDate2 |  | CHAR(7) | YES |
TEACHAmountPaidToDate3 |  | CHAR(7) | YES |
TEACHLastUpdateDate1 |  | CHAR(10) | YES |
TEACHLastUpdateDate2 |  | CHAR(10) | YES |
TEACHLastUpdateDate3 |  | CHAR(10) | YES |
TEACHAwardYear1 |  | CHAR(7) | YES |
TEACHAwardYear2 |  | CHAR(7) | YES |
TEACHAwardYear3 |  | CHAR(7) | YES |
TEACHAcademicYearLevel1 |  | CHAR(1) | YES |
TEACHAcademicYearLevel2 |  | CHAR(1) | YES |
TEACHAcademicYearLevel3 |  | CHAR(1) | YES |
TEACHCODSequenceCode1 |  | CHAR(3) | YES |
TEACHCODSequenceCode2 |  | CHAR(3) | YES |
TEACHCODSequenceCode3 |  | CHAR(3) | YES |
TEACHLoanConversionFlag1 |  | CHAR(1) | YES |
TEACHLoanConversionFlag2 |  | CHAR(1) | YES |
TEACHLoanConversionFlag3 |  | CHAR(1) | YES |
ChangeFlag1 |  | CHAR(1) | YES |
ChangeFlag2 |  | CHAR(1) | YES |
ChangeFlag3 |  | CHAR(1) | YES |
ChangeFlag4 |  | CHAR(1) | YES |
ChangeFlag5 |  | CHAR(1) | YES |
ChangeFlag6 |  | CHAR(1) | YES |
ProgramCode1 |  | CHAR(30) | YES |
ProgramCode2 |  | CHAR(30) | YES |
ProgramCode3 |  | CHAR(30) | YES |
ProgramCode4 |  | CHAR(30) | YES |
ProgramCode5 |  | CHAR(30) | YES |
ProgramCode6 |  | CHAR(30) | YES |
NetAmount1 |  | CHAR(8) | YES |
NetAmount2 |  | CHAR(8) | YES |
NetAmount3 |  | CHAR(8) | YES |
NetAmount4 |  | CHAR(8) | YES |
NetAmount5 |  | CHAR(8) | YES |
NetAmount6 |  | CHAR(8) | YES |
LoanBeginDate1 |  | CHAR(10) | YES |
LoanBeginDate2 |  | CHAR(10) | YES |
LoanBeginDate3 |  | CHAR(10) | YES |
LoanBeginDate4 |  | CHAR(10) | YES |
LoanBeginDate5 |  | CHAR(10) | YES |
LoanBeginDate6 |  | CHAR(10) | YES |
LoanEndDate1 |  | CHAR(10) | YES |
LoanEndDate2 |  | CHAR(10) | YES |
LoanEndDate3 |  | CHAR(10) | YES |
LoanEndDate4 |  | CHAR(10) | YES |
LoanEndDate5 |  | CHAR(10) | YES |
LoanEndDate6 |  | CHAR(10) | YES |
GaCode1 |  | CHAR(3) | YES |
GaCode2 |  | CHAR(3) | YES |
GaCode3 |  | CHAR(3) | YES |
GaCode4 |  | CHAR(3) | YES |
GaCode5 |  | CHAR(3) | YES |
GaCode6 |  | CHAR(3) | YES |
LoanSchoolCode1 |  | CHAR(8) | YES |
LoanSchoolCode2 |  | CHAR(8) | YES |
LoanSchoolCode3 |  | CHAR(8) | YES |
LoanSchoolCode4 |  | CHAR(8) | YES |
LoanSchoolCode5 |  | CHAR(8) | YES |
LoanSchoolCode6 |  | CHAR(8) | YES |
GradeLevel1 |  | CHAR(3) | YES |
GradeLevel2 |  | CHAR(3) | YES |
GradeLevel3 |  | CHAR(3) | YES |
GradeLevel4 |  | CHAR(3) | YES |
GradeLevel5 |  | CHAR(3) | YES |
GradeLevel6 |  | CHAR(3) | YES |
LoanContactCode1 |  | CHAR(8) | YES |
LoanContactCode2 |  | CHAR(8) | YES |
LoanContactCode3 |  | CHAR(8) | YES |
LoanContactCode4 |  | CHAR(8) | YES |
LoanContactCode5 |  | CHAR(8) | YES |
LoanContactCode6 |  | CHAR(8) | YES |
CurrentStatusCode1 |  | CHAR(2) | YES |
CurrentStatusCode2 |  | CHAR(2) | YES |
CurrentStatusCode3 |  | CHAR(2) | YES |
CurrentStatusCode4 |  | CHAR(2) | YES |
CurrentStatusCode5 |  | CHAR(2) | YES |
CurrentStatusCode6 |  | CHAR(2) | YES |
CurrentStatusDate1 |  | CHAR(10) | YES |
CurrentStatusDate2 |  | CHAR(10) | YES |
CurrentStatusDate3 |  | CHAR(10) | YES |
CurrentStatusDate4 |  | CHAR(10) | YES |
CurrentStatusDate5 |  | CHAR(10) | YES |
CurrentStatusDate6 |  | CHAR(10) | YES |
OutPrincipalBalance1 |  | CHAR(8) | YES |
OutPrincipalBalance2 |  | CHAR(8) | YES |
OutPrincipalBalance3 |  | CHAR(8) | YES |
OutPrincipalBalance4 |  | CHAR(8) | YES |
OutPrincipalBalance5 |  | CHAR(8) | YES |
OutPrincipalBalance6 |  | CHAR(8) | YES |
OutPrincipalBalanceDate1 |  | CHAR(10) | YES |
OutPrincipalBalanceDate2 |  | CHAR(10) | YES |
OutPrincipalBalanceDate3 |  | CHAR(10) | YES |
OutPrincipalBalanceDate4 |  | CHAR(10) | YES |
OutPrincipalBalanceDate5 |  | CHAR(10) | YES |
OutPrincipalBalanceDate6 |  | CHAR(10) | YES |
LoanContactType1 |  | CHAR(3) | YES |
LoanContactType2 |  | CHAR(3) | YES |
LoanContactType3 |  | CHAR(3) | YES |
LoanContactType4 |  | CHAR(3) | YES |
LoanContactType5 |  | CHAR(3) | YES |
LoanContactType6 |  | CHAR(3) | YES |
ExtraUnsubLoan1 |  | CHAR(20) | YES |
ExtraUnsubLoan2 |  | CHAR(20) | YES |
ExtraUnsubLoan3 |  | CHAR(20) | YES |
ExtraUnsubLoan4 |  | CHAR(20) | YES |
ExtraUnsubLoan5 |  | CHAR(20) | YES |
ExtraUnsubLoan6 |  | CHAR(20) | YES |
CapitalizedInterestFlag1 |  | CHAR(3) | YES |
CapitalizedInterestFlag2 |  | CHAR(3) | YES |
CapitalizedInterestFlag3 |  | CHAR(3) | YES |
CapitalizedInterestFlag4 |  | CHAR(3) | YES |
CapitalizedInterestFlag5 |  | CHAR(3) | YES |
CapitalizedInterestFlag6 |  | CHAR(3) | YES |
LoanTypeCode1 |  | CHAR(10) | YES |
LoanTypeCode2 |  | CHAR(10) | YES |
LoanTypeCode3 |  | CHAR(10) | YES |
LoanTypeCode4 |  | CHAR(10) | YES |
LoanTypeCode5 |  | CHAR(10) | YES |
LoanTypeCode6 |  | CHAR(10) | YES |
AmtofLastDisb1 |  | CHAR(8) | YES |
AmtofLastDisb2 |  | CHAR(8) | YES |
AmtofLastDisb3 |  | CHAR(8) | YES |
AmtofLastDisb4 |  | CHAR(8) | YES |
AmtofLastDisb5 |  | CHAR(8) | YES |
AmtofLastDisb6 |  | CHAR(8) | YES |
DateofLastDisb1 |  | CHAR(10) | YES |
DateofLastDisb2 |  | CHAR(10) | YES |
DateofLastDisb3 |  | CHAR(10) | YES |
DateofLastDisb4 |  | CHAR(10) | YES |
DateofLastDisb5 |  | CHAR(10) | YES |
DateofLastDisb6 |  | CHAR(10) | YES |
UserID |  | INTEGER | NO |
DateAdded |  | DATETIME | NO |
DateLstMod |  | DATETIME | NO |
ts |  | TIMESTAMP/DATE | NO |
ACGAwardYear1 |  | CHAR(4) | YES |
ACGAwardYear2 |  | CHAR(4) | YES |
ACGAwardYear3 |  | CHAR(4) | YES |
ACGPercentScheduled1 |  | CHAR(7) | YES |
ACGPercentScheduled2 |  | CHAR(7) | YES |
ACGPercentScheduled3 |  | CHAR(7) | YES |
ACGPercentUsed1 |  | CHAR(7) | YES |
ACGPercentUsed2 |  | CHAR(7) | YES |
ACGPercentUsed3 |  | CHAR(7) | YES |
ACGScheduledAmount1 |  | CHAR(7) | YES |
ACGScheduledAmount2 |  | CHAR(7) | YES |
ACGScheduledAmount3 |  | CHAR(7) | YES |
SMARTAwardYear1 |  | CHAR(4) | YES |
SMARTAwardYear2 |  | CHAR(4) | YES |
SMARTAwardYear3 |  | CHAR(4) | YES |
SMARTPercentScheduled1 |  | CHAR(7) | YES |
SMARTPercentScheduled2 |  | CHAR(7) | YES |
SMARTPercentScheduled3 |  | CHAR(7) | YES |
SMARTPercentUsed1 |  | CHAR(7) | YES |
SMARTPercentUsed2 |  | CHAR(7) | YES |
SMARTPercentUsed3 |  | CHAR(7) | YES |
SMARTScheduledAmount1 |  | CHAR(7) | YES |
SMARTScheduledAmount2 |  | CHAR(7) | YES |
SMARTScheduledAmount3 |  | CHAR(7) | YES |
TEACHScheduledAmount1 |  | CHAR(7) | YES |
TEACHScheduledAmount2 |  | CHAR(7) | YES |
TEACHScheduledAmount3 |  | CHAR(7) | YES |

FaNSLDSWork12 Keys

Key Name | Key Type | Keys
NK_FaNSLDSWork12_UserID | Inversion Entry | UserID
NK_FaNSLDSWork12_FaISIR12ID | Inversion Entry | FaISIR12ID
PK_FaNSLDSWork12_FaNSLDSWork12ID | PrimaryKey | FaNSLDSWork12ID

FaNSLDSWork12 Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
FaISIR12 | Non-Identifying | Zero or One to Zero or More |  |  |  | FaISIR12ID | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | UserID | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaNSLDSWork12 Check Constraints

Check Constraint Name | CheckConstraint

FaNSLDSWork12 Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaNSLDSWork12 | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaNSLDSWork12 | NO |  |  |

FaNSLDSWork12 Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaNSLDSWork12 Data Movement Rules

Name | Type | Rule Text/Value